Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	457
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	53.7 KiB
Average record size in memory	120.3 B

Variable types

Numeric	14
Categorical	1

Alerts

`TotalSteps` is highly correlated with `TotalDistance` and 8 other fields	High correlation
`TotalDistance` is highly correlated with `TotalSteps` and 8 other fields	High correlation
`TrackerDistance` is highly correlated with `TotalSteps` and 8 other fields	High correlation
`VeryActiveDistance` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`ModeratelyActiveDistance` is highly correlated with `TotalSteps` and 6 other fields	High correlation
`LightActiveDistance` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`VeryActiveMinutes` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`FairlyActiveMinutes` is highly correlated with `TotalSteps` and 6 other fields	High correlation
`LightlyActiveMinutes` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`Calories` is highly correlated with `TotalSteps` and 2 other fields	High correlation
`TotalSteps` is highly correlated with `TotalDistance` and 7 other fields	High correlation
`TotalDistance` is highly correlated with `TotalSteps` and 7 other fields	High correlation
`TrackerDistance` is highly correlated with `TotalSteps` and 7 other fields	High correlation
`VeryActiveDistance` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`ModeratelyActiveDistance` is highly correlated with `TotalSteps` and 2 other fields	High correlation
`LightActiveDistance` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`VeryActiveMinutes` is highly correlated with `TotalSteps` and 4 other fields	High correlation
`LightlyActiveMinutes` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`Calories` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`Id` is highly correlated with `LoggedActivitiesDistance` and 1 other fields	High correlation
`TotalSteps` is highly correlated with `TotalDistance` and 5 other fields	High correlation
`TotalDistance` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`TrackerDistance` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`LoggedActivitiesDistance` is highly correlated with `Id` and 4 other fields	High correlation
`VeryActiveDistance` is highly correlated with `SedentaryActiveDistance`	High correlation
`ModeratelyActiveDistance` is highly correlated with `SedentaryActiveDistance`	High correlation
`LightActiveDistance` is highly correlated with `TotalSteps` and 4 other fields	High correlation
`SedentaryActiveDistance` is highly correlated with `Id` and 7 other fields	High correlation
`LightlyActiveMinutes` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`Id` is highly correlated with `TotalSteps` and 6 other fields	High correlation
`ActivityDate` is highly correlated with `Calories`	High correlation
`TotalSteps` is highly correlated with `Id` and 9 other fields	High correlation
`TotalDistance` is highly correlated with `Id` and 9 other fields	High correlation
`TrackerDistance` is highly correlated with `Id` and 9 other fields	High correlation
`LoggedActivitiesDistance` is highly correlated with `SedentaryActiveDistance` and 1 other fields	High correlation
`VeryActiveDistance` is highly correlated with `Id` and 5 other fields	High correlation
`ModeratelyActiveDistance` is highly correlated with `TotalSteps` and 3 other fields	High correlation
`LightActiveDistance` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`SedentaryActiveDistance` is highly correlated with `LoggedActivitiesDistance`	High correlation
`VeryActiveMinutes` is highly correlated with `Id` and 4 other fields	High correlation
`FairlyActiveMinutes` is highly correlated with `ModeratelyActiveDistance`	High correlation
`LightlyActiveMinutes` is highly correlated with `Id` and 7 other fields	High correlation
`SedentaryMinutes` is highly correlated with `TotalSteps` and 5 other fields	High correlation
`Calories` is highly correlated with `Id` and 6 other fields	High correlation
`TotalSteps` has 61 (13.3%) zeros	Zeros
`TotalDistance` has 63 (13.8%) zeros	Zeros
`TrackerDistance` has 66 (14.4%) zeros	Zeros
`LoggedActivitiesDistance` has 433 (94.7%) zeros	Zeros
`VeryActiveDistance` has 245 (53.6%) zeros	Zeros
`ModeratelyActiveDistance` has 228 (49.9%) zeros	Zeros
`LightActiveDistance` has 74 (16.2%) zeros	Zeros
`SedentaryActiveDistance` has 419 (91.7%) zeros	Zeros
`VeryActiveMinutes` has 241 (52.7%) zeros	Zeros
`FairlyActiveMinutes` has 227 (49.7%) zeros	Zeros
`LightlyActiveMinutes` has 72 (15.8%) zeros	Zeros
`Calories` has 5 (1.1%) zeros	Zeros

Reproduction

Analysis started	2022-02-01 05:33:23.802776
Analysis finished	2022-02-01 05:33:47.331453
Duration	23.53 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	35
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4628594643

Minimum	1503960366
Maximum	8877689391
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	1503960366
5-th percentile	1624580081
Q1	2347167796
median	4057192912
Q3	6391747486
95-th percentile	8792009665
Maximum	8877689391
Range	7373729025
Interquartile range (IQR)	4044579690

Descriptive statistics

Standard deviation	2293781430
Coefficient of variation (CV)	0.4955675764
Kurtosis	-1.039194515
Mean	4628594643
Median Absolute Deviation (MAD)	2030840877
Skewness	0.3527246238
Sum	2.115267752 × 10¹²
Variance	5.261433247 × 10¹⁸
Monotonicity	Increasing

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
4057192912	32	7.0%
4020332650	32	7.0%
1503960366	19	4.2%
1624580081	19	4.2%
2347167796	15	3.3%
4702921684	15	3.3%
4445114986	15	3.3%
6962181067	14	3.1%
2320127002	12	2.6%
4558609924	12	2.6%
Other values (25)	272	59.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1503960366	19	4.2%
1624580081	19	4.2%
1644430081	10	2.2%
1844505072	12	2.6%
1927972279	12	2.6%
2022484408	12	2.6%
2026352035	12	2.6%
2320127002	12	2.6%
2347167796	15	3.3%
2873212765	12	2.6%

Value	Count	Frequency (%)
8877689391	12	2.6%
8792009665	12	2.6%
8583815059	8	1.8%
8378563200	12	2.6%
8253242879	12	2.6%
8053475328	11	2.4%
7086361926	12	2.6%
7007744171	12	2.6%
6962181067	14	3.1%
6775888955	9	2.0%

ActivityDate
Categorical

HIGH CORRELATION

Distinct	32
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

4/2/2016	35
4/3/2016	35
4/4/2016	35
4/5/2016	35
4/1/2016	34
Other values (27)	283

Length

Max length	9
Median length	8
Mean length	8.332603939
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3/25/2016
2nd row	3/26/2016
3rd row	3/27/2016
4th row	3/28/2016
5th row	3/29/2016

Common Values

Value	Count	Frequency (%)
4/2/2016	35	7.7%
4/3/2016	35	7.7%
4/4/2016	35	7.7%
4/5/2016	35	7.7%
4/1/2016	34	7.4%
4/6/2016	33	7.2%
4/7/2016	33	7.2%
4/8/2016	33	7.2%
4/9/2016	32	7.0%
4/10/2016	29	6.3%
Other values (22)	123	26.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4/2/2016	35	7.7%
4/5/2016	35	7.7%
4/3/2016	35	7.7%
4/4/2016	35	7.7%
4/1/2016	34	7.4%
4/6/2016	33	7.2%
4/7/2016	33	7.2%
4/8/2016	33	7.2%
4/9/2016	32	7.0%
4/10/2016	29	6.3%
Other values (22)	123	26.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TotalSteps
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	389
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6546.562363

Minimum	0
Maximum	28497
Zeros	61
Zeros (%)	13.3%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1988
median	5986
Q3	10198
95-th percentile	15605.6
Maximum	28497
Range	28497
Interquartile range (IQR)	8210

Descriptive statistics

Standard deviation	5398.493064
Coefficient of variation (CV)	0.824630205
Kurtosis	0.6648241126
Mean	6546.562363
Median Absolute Deviation (MAD)	4120
Skewness	0.803413395
Sum	2991779
Variance	29143727.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	61	13.3%
2098	2	0.4%
8	2	0.4%
5543	2	0.4%
12409	2	0.4%
4499	2	0.4%
6344	2	0.4%
4195	2	0.4%
7	2	0.4%
1988	1	0.2%
Other values (379)	379	82.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	13.3%
4	1	0.2%
7	2	0.4%
8	2	0.4%
14	1	0.2%
18	1	0.2%
20	1	0.2%
24	1	0.2%
44	1	0.2%
87	1	0.2%

Value	Count	Frequency (%)
28497	1	0.2%
27572	1	0.2%
25701	1	0.2%
24136	1	0.2%
23014	1	0.2%
20779	1	0.2%
20237	1	0.2%
20188	1	0.2%
19658	1	0.2%
18952	1	0.2%

TotalDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	334
Distinct (%)	73.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.663522972

Minimum	0
Maximum	27.53000069
Zeros	63
Zeros (%)	13.8%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.409999967
median	4.090000153
Q3	7.159999847
95-th percentile	11.23999977
Maximum	27.53000069
Range	27.53000069
Interquartile range (IQR)	5.749999881

Descriptive statistics

Standard deviation	4.082072268
Coefficient of variation (CV)	0.8753194296
Kurtosis	3.448976394
Mean	4.663522972
Median Absolute Deviation (MAD)	2.889999866
Skewness	1.321383526
Sum	2131.229998
Variance	16.663314
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	63	13.8%
0.009999999776	6	1.3%
4.71999979	3	0.7%
7.670000076	3	0.7%
5.409999847	2	0.4%
2.140000105	2	0.4%
3.839999914	2	0.4%
0.01999999955	2	0.4%
0.2599999905	2	0.4%
1.549999952	2	0.4%
Other values (324)	370	81.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	63	13.8%
0.009999999776	6	1.3%
0.01999999955	2	0.4%
0.02999999933	1	0.2%
0.1099999994	1	0.2%
0.1299999952	1	0.2%
0.1400000006	2	0.4%
0.1899999976	1	0.2%
0.2099999934	1	0.2%
0.2599999905	2	0.4%

Value	Count	Frequency (%)
27.53000069	1	0.2%
23.38999939	1	0.2%
20.90999985	1	0.2%
20.38999939	1	0.2%
20.13999939	1	0.2%
18.40999985	1	0.2%
15.81999969	1	0.2%
15.61999989	1	0.2%
14.84000015	1	0.2%
14.71000004	1	0.2%

TrackerDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	336
Distinct (%)	73.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.609846824

Minimum	0
Maximum	27.53000069
Zeros	66
Zeros (%)	14.4%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.279999971
median	4.090000153
Q3	7.110000134
95-th percentile	11.13599968
Maximum	27.53000069
Range	27.53000069
Interquartile range (IQR)	5.830000162

Descriptive statistics

Standard deviation	4.068539937
Coefficient of variation (CV)	0.8825759494
Kurtosis	3.576888152
Mean	4.609846824
Median Absolute Deviation (MAD)	2.920000076
Skewness	1.339050019
Sum	2106.699999
Variance	16.55301722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	66	14.4%
0.009999999776	6	1.3%
4.71999979	3	0.7%
7.670000076	3	0.7%
6.789999962	2	0.4%
6.150000095	2	0.4%
11.23999977	2	0.4%
1.919999957	2	0.4%
4.139999866	2	0.4%
1.429999948	2	0.4%
Other values (326)	367	80.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	66	14.4%
0.009999999776	6	1.3%
0.01999999955	2	0.4%
0.02999999933	1	0.2%
0.1099999994	1	0.2%
0.1299999952	1	0.2%
0.1400000006	2	0.4%
0.1899999976	1	0.2%
0.2099999934	1	0.2%
0.2599999905	2	0.4%

Value	Count	Frequency (%)
27.53000069	1	0.2%
23.38999939	1	0.2%
20.90999985	1	0.2%
20.38999939	1	0.2%
20.13999939	1	0.2%
18.40999985	1	0.2%
15.81999969	1	0.2%
15.61999989	1	0.2%
14.84000015	1	0.2%
14.71000004	1	0.2%

LoggedActivitiesDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	20
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1794273741

Minimum	0
Maximum	6.72705698
Zeros	433
Zeros (%)	94.7%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.3665432006
Maximum	6.72705698
Range	6.72705698
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8492318298
Coefficient of variation (CV)	4.733011526
Kurtosis	27.13615724
Mean	0.1794273741
Median Absolute Deviation (MAD)	0
Skewness	5.159788142
Sum	81.99830997
Variance	0.7211947008
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	433	94.7%
2.092147112	4	0.9%
2.253081083	3	0.7%
1.609344006	1	0.2%
5.189849854	1	0.2%
3.218688011	1	0.2%
4.869782925	1	0.2%
4.842319965	1	0.2%
4.875989914	1	0.2%
4.835720062	1	0.2%
Other values (10)	10	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	433	94.7%
0.05584299937	1	0.2%
1.609344006	1	0.2%
1.926301956	1	0.2%
2.027772903	1	0.2%
2.092147112	4	0.9%
2.253081083	3	0.7%
2.696455002	1	0.2%
3.218688011	1	0.2%
3.97279501	1	0.2%

Value	Count	Frequency (%)
6.72705698	1	0.2%
5.45686388	1	0.2%
5.189849854	1	0.2%
4.901282787	1	0.2%
4.875989914	1	0.2%
4.869782925	1	0.2%
4.842319965	1	0.2%
4.836380005	1	0.2%
4.835720062	1	0.2%
4.828032017	1	0.2%

VeryActiveDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	170
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.180897153

Minimum	0
Maximum	21.92000008
Zeros	245
Zeros (%)	53.6%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.309999943
95-th percentile	5.760000038
Maximum	21.92000008
Range	21.92000008
Interquartile range (IQR)	1.309999943

Descriptive statistics

Standard deviation	2.487158568
Coefficient of variation (CV)	2.106160186
Kurtosis	18.7096635
Mean	1.180897153
Median Absolute Deviation (MAD)	0
Skewness	3.73064421
Sum	539.669999
Variance	6.185957745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	245	53.6%
0.0700000003	6	1.3%
0.25	4	0.9%
0.3300000131	3	0.7%
0.2300000042	3	0.7%
0.5	3	0.7%
2.569999933	2	0.4%
0.07999999821	2	0.4%
0.05999999866	2	0.4%
0.8899999857	2	0.4%
Other values (160)	185	40.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	245	53.6%
0.009999999776	1	0.2%
0.01999999955	1	0.2%
0.03999999911	1	0.2%
0.05999999866	2	0.4%
0.0700000003	6	1.3%
0.07999999821	2	0.4%
0.09000000358	1	0.2%
0.1000000015	2	0.4%
0.1099999994	1	0.2%

Value	Count	Frequency (%)
21.92000008	1	0.2%
16.81999969	1	0.2%
14.72000027	1	0.2%
12.22000027	1	0.2%
12.06000042	1	0.2%
11.72999954	1	0.2%
11.10000038	1	0.2%
9.979999542	1	0.2%
9.970000267	1	0.2%
9.960000038	1	0.2%

ModeratelyActiveDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	140
Distinct (%)	30.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4786433252

Minimum	0
Maximum	6.400000095
Zeros	228
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.01999999955
Q3	0.6700000167
95-th percentile	2.089999914
Maximum	6.400000095
Range	6.400000095
Interquartile range (IQR)	0.6700000167

Descriptive statistics

Standard deviation	0.8309951707
Coefficient of variation (CV)	1.736146995
Kurtosis	11.87056988
Mean	0.4786433252
Median Absolute Deviation (MAD)	0.01999999955
Skewness	2.971412313
Sum	218.7399996
Variance	0.6905529737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	228	49.9%
0.1800000072	5	1.1%
0.25	5	1.1%
0.3300000131	4	0.9%
0.2599999905	4	0.9%
0.2300000042	4	0.9%
0.3700000048	4	0.9%
0.5299999714	4	0.9%
0.2199999988	4	0.9%
0.7900000215	4	0.9%
Other values (130)	191	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	228	49.9%
0.01999999955	1	0.2%
0.03999999911	2	0.4%
0.05000000075	3	0.7%
0.05999999866	1	0.2%
0.09000000358	1	0.2%
0.1000000015	1	0.2%
0.1199999973	2	0.4%
0.1299999952	1	0.2%
0.1400000006	1	0.2%

Value	Count	Frequency (%)
6.400000095	1	0.2%
5.489999771	1	0.2%
4.489999771	1	0.2%
4.440000057	1	0.2%
3.720000029	1	0.2%
3.680000067	1	0.2%
3.599999905	1	0.2%
3.339999914	1	0.2%
3.25999999	1	0.2%
3.119999886	1	0.2%

LightActiveDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	295
Distinct (%)	64.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.890196937

Minimum	0
Maximum	12.51000023
Zeros	74
Zeros (%)	16.2%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.8700000048
median	2.930000067
Q3	4.460000038
95-th percentile	6.515999985
Maximum	12.51000023
Range	12.51000023
Interquartile range (IQR)	3.590000033

Descriptive statistics

Standard deviation	2.237523344
Coefficient of variation (CV)	0.7741767752
Kurtosis	0.2750757813
Mean	2.890196937
Median Absolute Deviation (MAD)	1.749999762
Skewness	0.5215831453
Sum	1320.82
Variance	5.006510715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	74	16.2%
0.009999999776	7	1.5%
3.5	4	0.9%
4.610000134	4	0.9%
4.449999809	3	0.7%
3.210000038	3	0.7%
3.910000086	3	0.7%
4.679999828	3	0.7%
4.460000038	3	0.7%
5.269999981	3	0.7%
Other values (285)	350	76.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	74	16.2%
0.009999999776	7	1.5%
0.01999999955	1	0.2%
0.02999999933	1	0.2%
0.1099999994	1	0.2%
0.1299999952	2	0.4%
0.1400000006	1	0.2%
0.1700000018	1	0.2%
0.1899999976	1	0.2%
0.2099999934	2	0.4%

Value	Count	Frequency (%)
12.51000023	1	0.2%
12	1	0.2%
9.369999886	1	0.2%
8.619999886	1	0.2%
8.149999619	1	0.2%
8.079999924	1	0.2%
8.06000042	1	0.2%
8.020000458	1	0.2%
7.789999962	1	0.2%
7.559999943	1	0.2%

SedentaryActiveDistance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001903719882

Minimum	0
Maximum	0.1000000015
Zeros	419
Zeros (%)	91.7%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.009999999776
Maximum	0.1000000015
Range	0.1000000015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0084868013
Coefficient of variation (CV)	4.45800949
Kurtosis	54.03881246
Mean	0.001903719882
Median Absolute Deviation (MAD)	0
Skewness	6.566301549
Sum	0.8699999861
Variance	7.202579631 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	419	91.7%
0.009999999776	22	4.8%
0.02999999933	6	1.3%
0.03999999911	4	0.9%
0.01999999955	2	0.4%
0.05999999866	2	0.4%
0.1000000015	1	0.2%
0.05000000075	1	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	419	91.7%
0.009999999776	22	4.8%
0.01999999955	2	0.4%
0.02999999933	6	1.3%
0.03999999911	4	0.9%
0.05000000075	1	0.2%
0.05999999866	2	0.4%
0.1000000015	1	0.2%

Value	Count	Frequency (%)
0.1000000015	1	0.2%
0.05999999866	2	0.4%
0.05000000075	1	0.2%
0.03999999911	4	0.9%
0.02999999933	6	1.3%
0.01999999955	2	0.4%
0.009999999776	22	4.8%
0	419	91.7%

VeryActiveMinutes
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	85
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.62363239

Minimum	0
Maximum	202
Zeros	241
Zeros (%)	52.7%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	25
95-th percentile	78.4
Maximum	202
Range	202
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	28.91970375
Coefficient of variation (CV)	1.739674163
Kurtosis	6.928585794
Mean	16.62363239
Median Absolute Deviation (MAD)	0
Skewness	2.38473603
Sum	7597
Variance	836.3492648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	241	52.7%
1	11	2.4%
3	9	2.0%
4	8	1.8%
2	7	1.5%
18	7	1.5%
15	7	1.5%
7	7	1.5%
25	6	1.3%
5	6	1.3%
Other values (75)	148	32.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	241	52.7%
1	11	2.4%
2	7	1.5%
3	9	2.0%
4	8	1.8%
5	6	1.3%
6	3	0.7%
7	7	1.5%
8	4	0.9%
9	4	0.9%

Value	Count	Frequency (%)
202	1	0.2%
165	1	0.2%
128	1	0.2%
124	1	0.2%
123	1	0.2%
116	1	0.2%
113	1	0.2%
107	1	0.2%
106	1	0.2%
105	1	0.2%

FairlyActiveMinutes
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	62
Distinct (%)	13.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.07002188

Minimum	0
Maximum	660
Zeros	227
Zeros (%)	49.7%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	16
95-th percentile	46.4
Maximum	660
Range	660
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	36.20863518
Coefficient of variation (CV)	2.770357656
Kurtosis	224.7286191
Mean	13.07002188
Median Absolute Deviation (MAD)	1
Skewness	13.02940846
Sum	5973
Variance	1311.065262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	227	49.7%
6	14	3.1%
16	12	2.6%
8	11	2.4%
7	10	2.2%
11	9	2.0%
12	9	2.0%
17	9	2.0%
15	8	1.8%
9	8	1.8%
Other values (52)	140	30.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	227	49.7%
1	3	0.7%
2	3	0.7%
3	3	0.7%
4	7	1.5%
5	5	1.1%
6	14	3.1%
7	10	2.2%
8	11	2.4%
9	8	1.8%

Value	Count	Frequency (%)
660	1	0.2%
141	1	0.2%
133	1	0.2%
120	1	0.2%
114	1	0.2%
107	1	0.2%
101	1	0.2%
99	1	0.2%
81	2	0.4%
77	1	0.2%

LightlyActiveMinutes
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	251
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	170.0700219

Minimum	0
Maximum	720
Zeros	72
Zeros (%)	15.8%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	64
median	181
Q3	257
95-th percentile	348.6
Maximum	720
Range	720
Interquartile range (IQR)	193

Descriptive statistics

Standard deviation	122.2053721
Coefficient of variation (CV)	0.7185591605
Kurtosis	0.3822726388
Mean	170.0700219
Median Absolute Deviation (MAD)	90
Skewness	0.3525141968
Sum	77722
Variance	14934.15298
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	72	15.8%
1	6	1.3%
248	5	1.1%
230	4	0.9%
212	4	0.9%
276	4	0.9%
208	4	0.9%
153	3	0.7%
176	3	0.7%
241	3	0.7%
Other values (241)	349	76.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	72	15.8%
1	6	1.3%
2	3	0.7%
3	1	0.2%
6	1	0.2%
8	2	0.4%
9	1	0.2%
11	1	0.2%
12	1	0.2%
14	1	0.2%

Value	Count	Frequency (%)
720	1	0.2%
630	1	0.2%
586	1	0.2%
506	1	0.2%
491	1	0.2%
475	1	0.2%
422	1	0.2%
401	1	0.2%
397	1	0.2%
390	1	0.2%

SedentaryMinutes
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	315
Distinct (%)	68.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	995.2822757

Minimum	32
Maximum	1440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	32
5-th percentile	465.4
Q1	728
median	1057
Q3	1285
95-th percentile	1440
Maximum	1440
Range	1408
Interquartile range (IQR)	557

Descriptive statistics

Standard deviation	337.021404
Coefficient of variation (CV)	0.3386189146
Kurtosis	-0.6782227116
Mean	995.2822757
Median Absolute Deviation (MAD)	300
Skewness	-0.3655631139
Sum	454844
Variance	113583.4267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1440	63	13.8%
1181	4	0.9%
1439	4	0.9%
1125	3	0.7%
1150	3	0.7%
842	3	0.7%
1139	3	0.7%
700	3	0.7%
1055	3	0.7%
1328	3	0.7%
Other values (305)	365	79.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
32	1	0.2%
61	1	0.2%
75	1	0.2%
99	1	0.2%
146	1	0.2%
161	1	0.2%
187	1	0.2%
198	1	0.2%
207	1	0.2%
209	1	0.2%

Value	Count	Frequency (%)
1440	63	13.8%
1439	4	0.9%
1438	2	0.4%
1432	1	0.2%
1428	1	0.2%
1414	1	0.2%
1407	1	0.2%
1406	2	0.4%
1404	1	0.2%
1399	1	0.2%

Calories
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	383
Distinct (%)	83.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2189.452954

Minimum	0
Maximum	4562
Zeros	5
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	3.7 KiB

Quantile statistics

Minimum	0
5-th percentile	790.8
Q1	1776
median	2062
Q3	2667
95-th percentile	3716
Maximum	4562
Range	4562
Interquartile range (IQR)	891

Descriptive statistics

Standard deviation	815.4845229
Coefficient of variation (CV)	0.3724603999
Kurtosis	0.5200100199
Mean	2189.452954
Median Absolute Deviation (MAD)	422
Skewness	0.2363575209
Sum	1000580
Variance	665015.0071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1776	11	2.4%
1878	8	1.8%
2060	6	1.3%
1820	5	1.1%
0	5	1.1%
1920	5	1.1%
1429	5	1.1%
1324	4	0.9%
2188	3	0.7%
1935	3	0.7%
Other values (373)	402	88.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	1.1%
50	1	0.2%
182	1	0.2%
251	1	0.2%
399	2	0.4%
446	1	0.2%
489	1	0.2%
538	1	0.2%
600	1	0.2%
625	1	0.2%

Value	Count	Frequency (%)
4562	1	0.2%
4526	1	0.2%
4430	1	0.2%
4286	1	0.2%
4234	1	0.2%
4220	1	0.2%
4196	1	0.2%
4128	1	0.2%
4039	1	0.2%
4034	1	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Id	ActivityDate	TotalSteps	TotalDistance	TrackerDistance	VeryActiveDistance	ModeratelyActiveDistance	LightActiveDistance	VeryActiveMinutes	FairlyActiveMinutes	LightlyActiveMinutes	SedentaryMinutes	Calories
0	1503960366	3/25/2016	11004	7.11	7.11	2.57	0.46	4.07	33	12	205	804	1819
1	1503960366	3/26/2016	17609	11.55	11.55	6.92	0.73	3.91	89	17	274	588	2154
2	1503960366	3/27/2016	12736	8.53	8.53	4.66	0.16	3.71	56	5	268	605	1944
3	1503960366	3/28/2016	13231	8.93	8.93	3.19	0.79	4.95	39	20	224	1080	1932
4	1503960366	3/29/2016	12041	7.85	7.85	2.16	1.09	4.61	28	28	243	763	1886
5	1503960366	3/30/2016	10970	7.16	7.16	2.36	0.51	4.29	30	13	223	1174	1820
6	1503960366	3/31/2016	12256	7.86	7.86	2.29	0.49	5.04	33	12	239	820	1889
7	1503960366	4/1/2016	12262	7.87	7.87	3.32	0.83	3.64	47	21	200	866	1868
8	1503960366	4/2/2016	11248	7.25	7.25	3.00	0.45	3.74	40	11	244	636	1843
9	1503960366	4/3/2016	10016	6.37	6.37	0.91	1.28	4.18	15	30	314	655	1850

Last rows

	Id	ActivityDate	TotalSteps	TotalDistance	TrackerDistance	VeryActiveDistance	ModeratelyActiveDistance	LightActiveDistance	SedentaryActiveDistance	VeryActiveMinutes	FairlyActiveMinutes	LightlyActiveMinutes	SedentaryMinutes	Calories
447	8877689391	4/3/2016	15260	8.190000	8.190000	1.80	0.75	5.57	0.00	106	17	259	1058	3864
448	8877689391	4/4/2016	20779	18.410000	18.410000	11.73	0.65	6.00	0.00	78	16	208	1138	3662
449	8877689391	4/5/2016	10695	8.120000	8.120000	0.77	0.18	7.09	0.01	10	3	246	1181	2834
450	8877689391	4/6/2016	24136	20.910000	20.910000	12.22	0.54	8.08	0.00	87	16	318	1019	4039
451	8877689391	4/7/2016	10910	8.420000	8.420000	2.96	0.39	5.03	0.00	32	11	212	1185	2947
452	8877689391	4/8/2016	23014	20.389999	20.389999	11.10	0.63	8.62	0.00	70	29	359	982	4196
453	8877689391	4/9/2016	16470	8.070000	8.070000	0.00	0.02	8.02	0.00	90	9	289	1052	3841
454	8877689391	4/10/2016	28497	27.530001	27.530001	21.92	1.12	4.46	0.00	128	46	211	1055	4526
455	8877689391	4/11/2016	10622	8.060000	8.060000	1.47	0.15	6.37	0.01	18	7	225	1190	2820
456	8877689391	4/12/2016	2350	1.780000	1.780000	0.00	0.00	1.78	0.00	0	0	58	531	938

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows